play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95
Pro 3.0F!
Pro 3.0 - 4.0M1
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
split
11/5/99
AVAILABLE FOR SALE
INVENTORY CORRECTION MARKER
INVENTORY CORRECTION NOTES
INVENTORY COUNT
INVENTORY ID
INVOICE ID
ITEM FOR LABEL
ITEM WITH ID
LABEL PRINTED
LINE ITEM CREATION DATE
LINE ITEM CREATION TIME
LINE ITEM MODIFICATION DATE
LINE ITEM MODIFICATION TIME
LINE ITEM PURCHASED
LINE ITEM RECORD ID
LINE ITEM SOLD
MO ID BUILD
MO ID CONSUME
MY COST
PREFERED V PRODUCT PN
PRICE
PRODUCT ID ITEM CODE
PRODUCT ID RECORD NUMBER
PURCHASE ID
QUANTITY IN STOCK
QUANTITY PURCHASED
QUANTITY SOLD
RECORD NUMBER
REPORT NAME
SEARCH PERIOD
SEARCH PERIOD REPORT
STATUS
TODAY LINK
TOTAL LINE ITEM PURCHASED
TOTAL LINE ITEM SOLD
TOTAL QUANTITY PURCHASED
TOTAL QUANTITY SOLD
TOTAL RECORDS
VENDOR NAME
Invoice IDB
Product ID record numberB
ItemB
Quantity SoldB
PriceB
Line Item SoldB
Total RecordsB
Search Period
Report Menu
Find Dialog
Summarize by Month
Summarize by Day
Summarize by Week
Summarize by Year
Item inventory list
Line Item Particulars
Invoice PO pricing list
Line Item Inventory correction
5104 sheet
about
Import
Report MenuB
Search Period ReportB
Total Line Item SoldB
Total Quantity SoldB
Report NameB
Quantity PurchasedB
Total Quantity PurchasedB
Quantity in StockB
My CostB
Purchase IDB
Line Item PurchasedB
Total Line Item PurchasedB
Line item creation dateB
Line item modification dateB
Line item modification timeB
Line item creation timeB
Line Item record IDB
1000000
Inventory countB
statusB
Inventory correction markerB
Inventory correction notesB
Inventory IDB
) & "-" &
Item with IDB
& ", ID=" &
, ID=
Item for labelB
available for saleB
label printedB
prefered v product pnB
Vendor NameB
record numberB
today linkB
MO ID buildB
MO ID consumeB
Product ID item codeB
Find DialogB
ReportsU
ReportsV
Summarize
by DayW
Summarize
by WeekX
Summarize
by MonthY4Creating reports is quite easy and requires 3 steps:Z
3. Select the report below.[
Find Your Own\3There is currently <<
ABAH>> selected Line Item(s).]B1. Find the Invoices that you would like to create a report with.a:Select the correct search request or Find Your Own Recordsb
Summarize
by Yearc
2. Name your report. u
xv Item Listw
P. O. Listx
Clear Itemz
About{
Message|
Invoice}
Products~
Clients
Vendors
Close
Print
E Inventory
Invoice List
Modify Inventory Count
Purchase
Add Item
Print
Label sheet
Summarize by MonthB
Find a Line Item
Product ID record number
Price
Quantity Sold
Cancel
Invoice
Invoice Date
Summarize by DayB
Product ID record numberF
ItemH
Quantity SoldW
Summary Report by Month[
Search Range: <<
ABAJ>>h
Total Line Item Soldi
Printed //k
Page ##u
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
Summarize by WeekB
Product ID record numberF
ItemH
Quantity SoldW
Summary Report by Day[
Search Range: <<
ABAJ>>h
Total Line Item Soldi
Printed //k
Page ##u
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
Summarize by YearB
Product ID record numberF
ItemH
Quantity SoldW
Summary Report by Week[
Search Range: <<
ABAJ>>h
Total Line Item Soldi
Printed //k
Page ##u!Week of <<
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
Item inventory listB
Product ID record numberF
ItemH
Quantity SoldW
Summary Report by Year[
Search Range: <<
ABAJ>>h
Total Line Item Soldi
Printed //k
Page ##u
AFAAABADABAB>> totals:
Grand Totalw <<
ABAM>>
Line Item ParticularsB
1999 After Hours Consulting - Raleigh, NC - 919-271-7479
Bought
Record
Transaction date
Quantity in Stock
List Modified
O Show Item
P. O. List
Clear Item
About
Message
Invoice
Products
Clients
Vendors
Close
Print
^ Inventory
Invoice List
Modify Inventory Count
Purchase
Add Item
Correction
Invoice PO pricing listB
PriceD Invoice #F
ItemH
Line Item PurchasedJ
Line Item SoldL
CostN
Product ID record numberP
PO #R
Quantity in StockT
Quantity PurchasedV
Quantity Soldh
Creation date & timej
Modification date & timep
Recordr*Inventory count prior to this transaction:s Purchasesw
statusz Unlabeled{ Item List|
P. O. List~
Clear Item
About
Message
Invoice
Products
Clients
Vendors
Close
Print
M Inventory
Invoice List
Modify Inventory Count
Purchase
Add Item
Inventory ID
available for sale
label printed
prefered vendor product pn
1999 After Hours Consulting, Raleigh, NC
919/271-7479 All Rights Reserved.
MO ID build
MO ID consume
g item code
Line Item Inventory correctionB
Price
Record
Invoice
Invoice Total
Purchase ID
Purchase Total
U Item List
P. O. List
Clear Item
About
Message
Invoice
Products
Clients
Vendors
Close
Print
d Inventory
Invoice List
Modify Inventory Count
Purchase
Add Item
1999 After Hours Consulting, Raleigh, NC
919/271-7479 All Rights Reserved.
5104 sheetB
ABCC>>
ABCA>>
ABBI>>G
HelpB
Increase Stock Count by:
Decrease Stock Count by:
Creation date & time
Modification date & time
Record
r*Inventory count prior to this transaction:z
List Modified{ Item List|
P. O. List~
Clear Item
About
Message
Invoice
Products
Clients
Vendors
Close
Print
M Inventory
Invoice List
Modify Inventory Count
Purchase
Click on the New button above. Select the Item to correct from the Item field, then enter the amount to increase or decrease the recorded count by to reflect an accurate inventory.
inventory location
Correction:
Print
Label
label printed
Find unprinted
V 1.0.3
1999 After Hours Consulting, Raleigh, NC
919/271-7479 All Rights Reserved.
aboutB
TOTAL QUANTITY PURCHASED
FPTHA
FPTHA
FPTHA
FPTHA
FPTHA
FPTHA
FPTHA
FPTHA
RPTHA
alisA
alisA
alisA
About
Message
Invoice
Vendors
Purchase
Clients
Close
Print
After Hours Consulting, all rights reserved.
After Hours -- Confidential
This is a brief Help guide to your database.
The database has two main parts, the navigator bar above , and the body of the database, where you can store and use the information it holds. You may jump from one section of the database to another by clicking (once) on one of the nav buttons. The top row takes you to related databases such as your clients, POs, billing invoices and so forth. The active database is highlighted with the open file icon, and may take you to another layout
within the file. Inactive or unavailable buttons will be greyed out. The Quit button will save all of your work and Quit from FileMaker.
The second row navigates within this database, permitting the creation of new records, jumping to the first record, previous, next and last record, specialty menus, functions such as finding or printing a specific record, getting to this help page, or closing the file.
If there is a third row, it will be for additional specialty functions such as sort
Ying the working record set.
The body of each file contains the recorded information, so it's called the record. Each record is like a file card in a rolodex, and the files can be sorted, printed or separated into groups as needed. You will enter information into fields. Often you can jump from one field to the next by pressing the TAB key.
Import
Return
Products
ImportB
About
About Expert Consultant
This is a FileMaker Pro database, designed to aid the small business professional track their clients, vendors and operation on the Macintosh.
Expert Consultant is a standalone solution based in FileMaker 3.0.5. For complete features, the support files must be installed in your system folder or a commercial version of FileMaker Pro should reside on your hard drive.
Expert Consultant v1.2.6
1998, 1999 After Hours Consulting, all rights reserved.
i.This copy of Expert Consultant is licensed to:
Expert Consultant is a commercial package and is not for free distribution.
Individual and network site licenses are available.
Contact us for additional details.
After Hours Consulting Technical Support: 10-5 EST
on the web at: http://www.afterhoursconsulting.org
lAiWARNING: This solution contains password(s) which may only be provided by the developer identified above.
Products
Purchase
Vendors
Clients
Invoice
Message
t+Expert Consultant LineItem - Import feature
After Hours Consulting
Raleigh, NC, USA
919/271-7479
All Rights Reserved
This window permits the initial setup or importation of learnlog data from previous versions of EC or other business database software. To use EC effectively, most users prefer to keep records of important information (job-related news, tidbits, flotsam and jetsom which just doesn
t seem to belong anywhere else but is important enough for future reference).
You will need to conduct separate imports for each file in your current solution.
To import records from previous versions, we str
ongly suggest referring to the owners guide or printing out the instructions with the button below. Then, select the Start Import button. To forego using the learnlog file, select the Cancel button. To enter the learnlog file at any tme, select the Finished button.
When the import has finished, please inspect your new records for accuracy. To start the import, select the import button below. You may leave the import process by selecting the Finished button.
Start Import
Finished
Print instructions
Cancel
Rd/C}
After Hours
H"change printed label status to yes
find unlabeled
find unprinted
print label sheet
Create a new MO consumed entry
Create a new MO build entry
print import instructions
import old data
X-import old data retaining price modifications
Go to Main Menu
Go to Reports Menu
Perform Find
Summarize by Day
Summarize by Week
Summarize by Month
Summarize by Year
Find from Report
"I'll Perform the Find"
I'll Perform the FindB
"I'll Perform the Find"
I'll Perform the Find
= "Last Week"
b)-1)-7) & "..." &
b+ (7 -
b)-7))
= "This Week"
b)-1)) & "..." &
b+ (7 -
= "Last Month"
b))) & "..." &
b)) -1)
= "This Month"
b))) & "..." &
b) + 1
b)) -1)
= "Last Year"
"1/1/" & (
)) -1) & "..." &
"12/31/" & (
))-1)
= "This Year"
"1/1/" &
)) & "..." &
"12/31/" &
= "I'll Perform the Find"
Last Week
This Week
Last Month
This Month
Last Year
1/1/
12/31/
This Year
1/1/
12/31/
I'll Perform the Find
) = 0
Cancel
:;<=>?@ABCDE
"#+./345>ABCGIL
&*268:H
There are no records that match your reports find request.H
Cancel
ADDFIELDSHRINKAGE
Please Select a find request.
A,List line items __ totalling script for P.O.
Create a new Invoice entry
Create a new Purchase entry
clear record
Cancel!
This action will eliminate the line item, and modify related purchases and sales. Doing so is irreversable. To clear this record, select Continue to the left. To save this information and cancel this action, select Cancel to the left.
sort by item
sort by invoice
sort by purchase order
open clients
open purchase
open invoice
open vendors
open products
open messages
about
go to first
go to previous
go to next
go to last
go to inventory
modify inventory count
sort by record
sort by invoice id
sort by purchase id
sort by item alone
list inventory modifications
go to labels
)A"change printed label status to yes
find unlabeled
print label sheet
CancelV
There are at least 30 records, so one sheet will be printed. Please be sure to select that only one sheet of labels is printed (print page 1 to 1, browsed records) in the print dialog box that will appear next.
Cancel
The page has been printed as you instructed. After printing, inspect the labels and mark off in the line items database which labels are acceptable by selecting the label printed option for each record.
find unprinted
startup
) < 1
Cancel
There are no records in the LineItems file presently. If you are upgrading, please import your records now. Otherwise, select Finished to return to the normal LineItems screen.C9
= "Network"
Network
Create a new MO consumed entry
Cancel
There are less than 30 labels to be printed, so some labels will be wasted. If you want to abort the printing, select Cancel in the next window.
Cancel
The page has been printed as you instructed. After printing, inspect the labels and mark off in the line items database which labels are acceptable by selecting the label printed option for each record.
Create a new MO build entry
print import instructions
import old data
Cancel
You are about to begin the Import process for LineItem. Your source file should be prepared (Find All, if appropriate). You may cancel in the next window, but do not cancel once the importation has begun.
Cancel
You have imported your old data. Due to the manner in which some businesses modify pricing on the fly, we you to run the following correction for your file. (Select OK)
2A-import old data retaining price modifications
Cancel
You are about to update pricing corrections in LineItems. You should select "Replace Existing Data" and not use the Auto-entry feature for this procedure.B
Cancel
Your data import for Lineitem is complete.
startup
open clients
open purchase
open invoice
open vendors
open products
open messages
about
,List line items __ totalling script for P.O.
Go to Main Menu
Go to Reports Menu
Perform Find
Summarize by Day
Summarize by Week
Summarize by Month
Summarize by Year
Find from Report
Create a new Invoice entry
Create a new Purchase entry
clear record
sort by item
sort by invoice
sort by purchase order
go to labels
go to first
go to previous
go to next
go to last
go to inventory
modify inventory count
sort by record
sort by invoice id
sort by purchase id
sort by item alone
list inventory modificationsons
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!#34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
DDDDDD
wwwwww
ffffff
333333
""""""
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"#C0
4""#C0
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
wwwwww
wwwwww
wwwwww
"%UR
UD33D
wwwwww
ffffff
DDDDDD
333333
w"23'
2!{w~
R!{wB
+r$r!w{~
""'r!{w~
r!ww~
'w!w|~
""q|{~
-"!{y~
+"!yy
44444
CCCCC 44444 CCCCC
$42"
(LIST
LISTAYLast Week
This Week
Last Month
This Month
Last Year
This Year
I'll Perform the Find
VDEFA(
(LIST
VDEFA(
(LIST
LISTA"Shipping
Backordered
Discontinued
VDEFA(
(LIST
VDEFA(
Search ValuesB
products listC
statusD
item location
FMRLA
FMRLA
FMRLA
FMRLA
ProductsC
Invoice IDF
purchaseG
setup
QMSPC
FPTHAQDaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:products.fp3
MSPCA
NAMEA
products.fp3
RPTHA
products.fp3
SRPTA
products.fp3
OMSPC
FPTHAOAPS Drive
:Projects:Franz Project:FM Pro Solution:13-More Changes:Main Menu.fp3
MSPCA
NAMEA
Main Menu.fp3
RPTHA
Main Menu.fp3
SRPTA
main_mnu.fp3
NMSPC
FPTHANAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:invoices.fp3